Hi, I am newibe in ssrs 2008 reports. I createa a tabular Report. In my report has rows group "Region", "State", and "City" and Column is "Count". I create a report with rows as "Region", "State" and column Count. I create another report with rows "City" and Columns "Count". if i run the first report i want to show link for the second report, which clicks on to shows the second report which has a value for City and count only for corresponding "Region" and "State" parameter.How Can i do it. Regards Dileep Sanker

Hi Dileep Can you give some more information which Functionality you need to impliment, Whether to create drill down or drillthrough in SSRS. Please use below links for more details on drill down & Drillthrough in reports. Drill Down - http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/creating-a-basic-drilldown-report-in-ssr-2005 http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/ Drill through - http://shahfaisalmuhammed.wordpress.com/2010/01/09/passing-parameters-to-a-drillthrough-report-in-ssrs/ http://www.mssqltips.com/sqlservertip/1297/reporting-services-condition-based-drill-through-reports/ http://blogs.technet.com/b/andrew/archive/2008/07/31/reporting-services-drill-through-for-a-matrix-report.aspxSuhas | Mark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.

This is not helpful for me.How its possible.?I use one "jump report" option and select report url and write the expression here with querystring. But it shows all the city name.I need to show the city name with corresponding Querystring. Regards, Dileep

hi dileep, Rclick on the textbox where you want to click --> actions --> Go to URL --> select the report from the drop down list --> click on add to add the parameters which you want to pass and run the report. hope this might help you. Regards, NVAMSK

Hi NVAMSK, This is not Correct one . In my Report I want to filter the data "Region", "State" wise . The "Region","State" are row groups. How can i do that.? Regards Dileep

Hi Dileep, Thanks for your feedback. According to your description, you would like to take use of Go to Report Action to pass the group fields value(“Region”,”State”) to your subreport, as a result, the subreport would show the cities corresponding to the fields values of “Region” and “State”. If so, please refer to the steps below: 1. In the Action page, check the Go to report item. 2. Choose the relevant subreport item in the Specify a report drop down list. 3. Click Add, choose the Region parameter in the Name drop down list, and click the fx button next to value drop down list, type the expression like below: =Fields!Region.Value 4. Click Add, choose the State parameter in the Name drop down list, and click the fx button next to value drop down list, type the expression like below: =Fields!State.Value 5. Click ok to finish it. After you complete the steps above, run your report to verify whether it works as you expected. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Bill, If i am doing the same way, I got The all the city name and Count . I want to show the city which belongs coressponding Region and state. For example , i have a Region like "Middle" and state like "CA" . Under this region and state, i have only three city name. How can i show the 3 city for corresponding Region and City.? Regards Dileep

Hi Dileep, Thanks for your feedback. The parameters name show in the drop down list were actually your subreport’s parameters’ name, and the value column was used to specify the field value of your main report. Moreover, please refer to the link below to obtain more detailed info about Add a drill through action on a report :http://technet.microsoft.com/en-us/library/dd207031.aspx Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Bill, Now the parameter is coming the second report and the corresponding parameters showed in the second report. But the second report shows all data without Filteration. What Can i do.? Regards Dileep

Hi Dileep, You need to associate the second report’ parameters to the relevant dataset, as a result, the parameter would assist you to filter the data. You can either create filters on your dataset or tablix, or then bind the relevant parameter to the each filter (Such as: select the relevant field as expression, specified the parameter as value). Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Bill, This is not helpful for me. Regards Dileep

Hi Dileep, I would suggest you to verify whether you bind the parameter value correctly to the relevant column field in your dataset. You can choose to show the relevant parameter values on your second report to verify whether the relevant field value in main report was passed to your second report successfully, you can also run your second report directly, and type in the field value (which you would pass from your main report to second report) to the parameter textbox to verify whether it works fine. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.